Q Part 1 - Setup Using this Template (XLSX), Download Template (XLSX), create a food log that records your meals and snacks for one day. Refer to the Food Table sheet of the template for information on the total calories based on portion sizes for various food items. For estimates of the amounts of calories, which you need to maintain calorie balance, will depend on your age, sex, and one of three different levels of physical activity, visit Dietary Guidelines. Links to an external site.Consolidate identical food items with the same portion size. Part 2 - Goal Seek Identify the input and output cells for the formulas in your food log table. Describe the relationship(s) between these cells. Based on your eating habits/pattern you recorded, define your dietary goal. Use Goal Seek, repeatedly, if necessary, to investigate what input values result in targeted output. When documenting the Goal Seek process, be sure to describe the steps and include any relevant illustrations. Submit both the Excel workbook and a Word® document for this activity. ________________________________________ Save your assignments using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.
View Related Questions